/*河南星辰软件科技有限公司
@copyright Copyright (c) 2010~2022 All rights reserved.
*/
package cn.javaxc.system.action.system;
import java.io.*;
import java.util.*;
import java.sql.*;
import cn.javaxc.model.base.SQL;
import cn.javaxc.model.base.SQLList;
import cn.javaxc.model.base.SQLMap;
import cn.javaxc.model.base.SQLParam;
import cn.javaxc.model.page.BatisPage;
import cn.javaxc.mvcwork.controller.web.TreeBean;
import cn.javaxc.mvcwork.util.common.CommonUtil;
import cn.javaxc.mvcwork.util.common.MapListUtil;
import cn.javaxc.mvcwork.util.helper.FrameHelper;
import cn.javaxc.mvcwork.util.helper.TreeTableHelper;
import org.springframework.beans.factory.annotation.Autowired;
import cn.javaxc.system.action.base.BaseAction;
import cn.javaxc.system.mapper.system.SystemListMapper;
public class SystemList extends BaseAction
{
    @Autowired(required=false)
	private SystemListMapper mapper;
    /**
    系统字典
    */
    
    public Map systemList() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_link=mapper.s_link(params);
        result.put("s_link", s_link);
        
        return result;
    }
    /**
    系统字典
    */
    
    public Map systemPubRelationList() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_lookuplist=mapper.s_lookuplist(params);
        s_lookuplist.setSelectNone("系统列表明细");
        result.put("s_lookuplist", s_lookuplist);
        
        return result;
    }
    /**
    修改名称
    */
    
    public Map upName() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_ts=mapper.t_ts(params);
        SQLMap t_ts_emt=t_ts.getExistfirst();
        result.put("t_ts", t_ts_emt);
        
        return result;
    }
    /**
    系统列表明细
    */
    
    public Map systemPubRelationListDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_ts=mapper.t_ts(params);
        SQLMap t_ts_emt=t_ts.getExistfirst();
        result.put("t_ts", t_ts_emt);
        
        return result;
    }
    /**
    */
    
    public Object s_table() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        
        
        params.put("CMID3",getSysList("CMID3"));
        SQLList<SQLMap> s_table=mapper.s_table(params);
        result.put("s_table", s_table);
        
        return s_table;
    }
    /**
    系统分组明细
    */
    
    public Map systemListDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.put("CMID3",getSysList("CMID3"));
        SQLList<SQLMap> s_table=mapper.s_table(params);
        result.put("s_table", s_table);
        
        return result;
    }
    /**
    修改
    */
    
    public Map systemListDetAdd() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.put("CMID3",getSysList("CMID3"));
        SQLList<SQLMap> s_table=mapper.s_table(params);
        SQLMap s_table_emt=s_table.getExistfirst();
        result.put("s_table", s_table_emt);
        
        return result;
    }
    /**
    修改
    */
    
    public Map systemListUp() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.put("CMID3",getSysList("CMID3"));
        SQLList<SQLMap> s_table=mapper.s_table(params);
        SQLMap s_table_emt=s_table.getExistfirst();
        result.put("s_table", s_table_emt);
        
        return result;
    }
    /**
    修改名称修改
    */
    
    public Map upNameSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.upNameSubmit(params);
        
        return result;
    }
    /**
    */
    
    public Map d_table() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        params.put("CMID3",getSysList("CMID3"));
        int d_table = mapper.d_table(params);
        result.put("d_table", d_table);
        
        return result;
    }
    /**
    系统列表明细修改
    */
    
    public Map systemPubRelationListDetSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.put("CMID3",getSysList("CMID3"));
        int u_table = mapper.u_table(params);
        result.put("u_table", u_table);
        
        return result;
    }
    /**
    */
    
    public Map d_ptable() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.put("CMID3",getSysList("CMID3"));
        int d_par_code = mapper.d_par_code(params);
        result.put("d_par_code", d_par_code);
        
        return result;
    }
    /**
    修改修改
    */
    
    public Map systemListDetAddSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.put("CMID3",getSysList("CMID3"));
        int u_table = mapper.u_table(params);
        result.put("u_table", u_table);
        
        return result;
    }
    /**
    增加一行修改
    */
    
    public Map systemListDetUpSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.put("CMID3",getSysList("CMID3"));
        int i_table = mapper.i_table(params);
        result.put("i_table", i_table);
        
        return result;
    }
    /**
    增加一行修改
    */
    
    public Map systemListAddSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        params.put("CMID3",getSysList("CMID3"));
        int i_table = mapper.i_table(params);
        result.put("i_table", i_table);
        
        return result;
    }
    /**
    修改修改
    */
    
    public Map systemListUpSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        params.put("CMID3",getSysList("CMID3"));
        int u_table = mapper.u_table(params);
        result.put("u_table", u_table);
        
        return result;
    }
}